{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["戸建・併用住宅用"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"戸建・併用住宅用","index":0,"n_rows":499,"n_cols":32,"rows_kept":499,"cut":false,"hidden":false,"merged":[[29,4,29,5],[29,9,29,10],[30,9,30,11],[30,6,30,8],[30,4,30,5],[33,1,33,3],[34,5,37,5],[34,6,37,6],[27,1,27,3],[27,4,27,5],[34,7,37,7],[37,1,37,4],[99,7,99,8],[15,14,16,17],[18,2,20,3],[18,1,24,1],[18,9,18,11],[23,11,24,11],[21,9,22,9],[23,9,24,9],[18,4,18,6],[19,4,19,6],[20,4,20,6],[16,7,16,8],[16,9,16,10],[15,7,15,8],[21,7,21,8],[22,7,22,8],[16,4,17,6],[29,1,29,3],[5,9,5,10],[20,7,20,8],[23,7,23,8],[17,7,17,8],[18,7,18,8],[3,1,3,3],[23,2,24,3],[23,4,23,6],[6,1,15,1],[7,2,7,6],[11,7,11,8],[7,7,7,8],[16,1,17,1],[13,4,13,6],[24,7,24,8],[13,2,13,3],[14,2,14,3],[13,9,15,11],[33,29,36,29],[33,28,36,28],[33,26,36,26],[33,27,36,27],[4,4,4,6],[5,1,5,3],[5,4,5,5],[4,1,4,3],[4,7,4,8],[20,16,20,17],[19,14,20,14],[19,15,19,17],[21,16,23,17],[7,9,7,11],[8,7,8,8],[8,9,8,11],[8,2,8,6],[7,19,8,20],[24,4,24,6],[28,10,28,11],[19,18,19,20],[4,9,4,11],[6,2,6,6],[15,20,16,20],[47,1,47,3],[67,4,67,5],[68,4,68,5],[42,10,43,10],[42,8,43,8],[49,6,51,6],[49,7,51,7],[49,8,51,8],[67,2,67,3],[68,2,68,3],[66,4,66,5],[66,1,68,1],[66,2,66,3],[44,4,45,4],[44,7,45,7],[54,6,55,7],[54,8,55,10],[44,1,44,3],[42,7,43,7],[49,1,49,3],[61,1,64,1],[53,4,53,10],[49,9,51,9],[50,5,51,5],[61,2,62,2],[53,1,53,3],[54,4,55,5],[61,3,61,5],[61,6,61,10],[51,1,51,3],[49,10,51,10],[56,4,59,5],[56,6,59,6],[56,7,59,7],[56,8,59,8],[54,1,54,3],[55,1,55,3],[46,1,46,3],[17,9,17,10],[19,7,19,8],[29,7,29,8],[105,24,107,24],[106,17,106,21],[107,17,107,21],[105,14,107,16],[105,17,105,21],[105,22,105,23],[106,22,106,23],[107,22,107,23],[104,14,104,24],[47,4,47,10],[61,11,62,11],[21,18,22,18],[21,15,23,15],[28,1,28,3],[28,4,28,5],[34,8,37,8],[50,4,51,4],[48,4,49,4],[44,11,45,11],[48,5,49,5],[118,23,118,24],[119,15,119,22],[120,15,120,22],[115,15,115,17],[116,15,117,17],[116,18,116,19],[116,21,116,22],[108,22,108,23],[110,22,110,23],[116,23,116,24],[117,18,117,19],[117,21,117,22],[108,17,108,21],[109,22,109,23],[109,17,109,21],[117,23,117,24],[110,17,110,21],[118,21,118,22],[108,14,111,16],[111,17,111,21],[111,22,111,23],[126,15,126,17],[126,18,126,19],[127,15,127,17],[127,18,127,19],[118,15,118,20],[128,14,128,17],[128,18,128,19],[115,14,120,14],[125,18,125,19],[125,14,125,17],[124,14,124,17],[124,18,124,19],[10,9,10,11],[38,1,38,3],[40,1,40,3],[41,1,41,3],[43,1,43,3],[40,10,41,11],[42,11,43,11],[44,5,45,5],[42,1,42,3],[45,1,45,3],[44,8,45,8],[44,10,45,10],[38,4,38,11],[42,4,43,4],[42,5,43,5],[40,4,41,5],[40,7,41,8],[10,2,10,6],[22,4,22,6],[35,1,35,3],[30,1,30,3],[34,9,37,9],[34,10,37,10],[33,5,33,10],[99,10,99,11],[21,20,23,20],[24,15,24,20],[3,4,3,6],[5,7,5,8],[9,2,9,6],[14,4,14,6],[15,2,15,6],[10,7,10,8],[6,7,6,8],[6,9,6,11],[11,9,11,11],[12,7,12,8],[12,9,12,11],[11,2,11,6],[12,2,12,6],[21,2,22,3],[21,4,21,6],[9,7,9,8],[9,9,9,11],[13,7,13,8],[14,7,14,8],[16,2,17,3],[15,18,16,19]]}
[null,"■　【BELS】住宅用一次エネルギー消費量計算書",null,null,null,null,null,null,null,null,null,"Ver.12.4"]
[]
[null,"1. 一次エネルギー消費量・断熱性能",null,null,null,null,null,null,null,null,null,{"$f":"E156","v":""},null," 【本計算書の使用方法と注意事項】"]
[null,"住宅タイプの名称",null,null,{"$f":"IF(ISERROR(IF(RIGHT(E105,3)=\"住宅)\",LEFT(E105,LEN(E105)-7),LEFT(E105,LEN(E105)-8))),\"\",IF(RIGHT(E105,3)=\"住宅)\",LEFT(E105,LEN(E105)-7),LEFT(E105,LEN(E105)-8)))","v":""},null,null,"建て方",{"$f":"IF(ISERROR(IF(RIGHT(E105,3)=\"住宅)\",MID(E105,(LEN(E105)-4),4),MID(E105,(LEN(E105)-5),4))),\"\",IF(RIGHT(E105,3)=\"住宅)\",MID(E105,(LEN(E105)-4),4),MID(E105,(LEN(E105)-5),4)))","v":""},"地域の区分",{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(SUBSTITUTE(D107,\"区分\",\"*\",2),FIND(\"*\",SUBSTITUTE(D107,\"区分\",\"*\",2))+1,3),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(SUBSTITUTE(D107,\"区分\",\"*\",2),FIND(\"*\",SUBSTITUTE(D107,\"区分\",\"*\",2))+1,3),ROW($1:$16))))","v":""},"地域",null," ①　本計算書を添付することで、BELS設計内容説明書 第二面の数値記入を省略することができます。"]
[null,"断熱性能評価手法",null,null,{"$f":"IF(AND(OR(K4<>\"\",E4<>\"\"),D156=\"\"),R139,IF(MID(D134,14,13)=\"当該住戸の外皮面積を用いて\",S135,IF(MID(D134,14,4)=\"仕様基準\",S136,IF(MID(D134,14,6)=\"誘導仕様基準\",S137,\"\"))))","v":""},null,null,"一次エネルギー評価手法",null,{"$f":"IF(AND(OR(K4<>\"\",E4<>\"\"),D156=\"\"),R139,IF(J100<>\"\",R135,\"\"))","v":""},null,null,null," ②　本計算書を再利用すると計算式が削除されている可能性があるため、常に新しい計算書をご使用ください。"]
[null,"計算対象床面積（合計）",null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(LEFT(D106,LEN(D106)-1),ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(LEFT(D106,LEN(D106)-1),ROW($1:$16))))","v":""},null,"㎡","非住宅の評価対象床面積",null,{"$f":"IF(I4=\"\",\"\",IF(I4=\"戸建住宅\",0,IF(S16=\"\",0,S16)))","v":""},null,"㎡"]
[null,"一次エネルギー消費量","内訳",null,null,null,null,"設計一次 [MJ]",null,"基準一次 [MJ]",null,null,null," 【本計算書の作成方法】"]
[null,null,"暖房設備",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(D108,5,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(D108,5,15),ROW($1:$16))))","v":""},null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(D108,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(D108,ROW($1:$16))))","v":""},null,null,null," ①　右のボタンで一次エネルギー消費量計算結果のPDFを読み込む。",null,null,null,null,null,"ＰＤＦ読込"]
[null,null,"冷房設備",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(D109,5,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(D109,5,15),ROW($1:$16))))","v":""},null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(D109,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(D109,ROW($1:$16))))","v":""},null,null,null,"　　　※ 住宅名称、太陽光の合計容量等に相違があれば修正してください。"]
[null,null,"換気設備",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(D110,5,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(D110,5,15),ROW($1:$16))))","v":""},null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(D110,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(D110,ROW($1:$16))))","v":""},null,null,null,"　　　※ PDFのマクロ読込に失敗するときは、PDFをデスクトップに置くか "]
[null,null,"給湯設備",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(D111,5,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(D111,5,15),ROW($1:$16))))","v":""},null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(D111,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(D111,ROW($1:$16))))","v":""},null,null,null,"　　　　  PDFを全選択・コピーして【Ｊ100】セルにペーストしてください。"]
[null,null,"照明設備",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(D112,5,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(D112,5,15),ROW($1:$16))))","v":""},null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(D112,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(D112,ROW($1:$16))))","v":""},null,null,null,"　　　　  （左表の黄色セルに計算結果データを直接入力しても可）"]
[null,null,"その他の設備",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(D113,7,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(D113,7,15),ROW($1:$16))))","v":""},null,{"$f":"IF(ISBLANK(H13),\"\",H13)","v":""}]
[null,null,"発電設備の発電量のうち",null,"太陽光発電（PV）",null,null,{"$f":"IF(ISERROR(LOOKUP(10^17,1*RIGHT(LEFT(D114,LEN(D114)-3),ROW($1:$16)))),\"\",IF(RIGHT(LEFT(D114,LEN(D114)-3),3)=\"---\",\"\",LOOKUP(10^17,1*RIGHT(LEFT(D114,LEN(D114)-3),ROW($1:$16)))))","v":""},null,"発電設備が無い場合は\n０を記入、又は空欄とする",null,null,null," ②　併用住宅で非住宅部分と太陽光発電設備を共有している場合、非住宅の床面積を入力してください。"]
[null,null,"自家消費分（マイナス値）",null,"コージェネレーション設備（CGS）",null,null,{"$f":"IF(ISERROR(LOOKUP(10^17,1*RIGHT(LEFT(D115,LEN(D115)-3),ROW($1:$16)))),\"\",IF(RIGHT(LEFT(D115,LEN(D115)-3),3)=\"---\",\"\",LOOKUP(10^17,1*RIGHT(LEFT(D115,LEN(D115)-3),ROW($1:$16)))))","v":""},null,null,null,null,null,"　　　（ZEH等の適合判断では、総発電量を床面積按分した値を太陽光のエネルギー消費削減分の上限とします）"]
[null,null,"コージェネレーション設備の売電量に係る控除量（マイナス値）",null,null,null,null,{"$f":"IF(ISERROR(LOOKUP(10^17,1*RIGHT(LEFT(D116,LEN(D116)-3),ROW($1:$16)))),\"\",IF(RIGHT(LEFT(D116,LEN(D116)-3),3)=\"---\",\"\",LOOKUP(10^17,1*RIGHT(LEFT(D116,LEN(D116)-3),ROW($1:$16)))))","v":""},null,null,null,null,null,null,"太陽光発電設備を共有する非住宅の評価対象床面積",null,null,null,null,null,"㎡"]
[null,"ＢＥＩ","建築物エネルギー\n消費性能基準",null,"一次エネルギー消費量（その他除く）",null,null,"設計一次[GJ/(戸･年)]",null,"基準一次[GJ/(戸･年)]",null,"BEI"]
[null,null,null,null,null,null,null,{"$f":"IF(SUM(AA180)=0,\"\",SUM(AA180))","v":""},null,{"$f":"IF(SUM(AA179)=0,\"\",SUM(AA179))","v":""},null,{"$f":"IF(SUM(AA181)=0,\"\",SUM(AA181))","v":""}]
[null,"参考値","設計二次エネルギー消費量",null,"消費電力量　　  [kWh]",null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(E146,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(E146,ROW($1:$16))))","v":""},null,"断熱性能",null,null,null," ③　「2. BELS評価申請項目」を入力、確認する。下の選択肢、又は左の表で直接選択してください。"]
[null,null,null,null,"ガス消費量 　　 [MJ]",null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(E147,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(E147,ROW($1:$16))))","v":""},null,null,"ＵＡ","ηＡＣ",null,null,"選択","再エネ設備",null,null,"目安光熱費"]
[null,null,null,null,"灯油消費量 　　 [MJ]",null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(E148,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(E148,ROW($1:$16))))","v":""},null,"設計値",{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(LEFT(E135,LEN(E135)-5),ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(LEFT(E135,LEN(E135)-5),ROW($1:$16))))","v":""},{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(E136,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(E136,ROW($1:$16))))","v":""},null,null,null,"容量表示","太陽光以外の再エネ設備",null,"表示","ガス設備","（参考値※）",{"$f":"IF(OR(J31=V135,J31=V136),\"※燃料単価\",\"\")","v":""}]
[null,null,"発電量［MJ］",null,"コージェネレーション",null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(E150,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(E150,ROW($1:$16))))","v":""},null,"基準値",{"$f":"IF(ISERROR(VLOOKUP(K4,O146:Q153,2)),\"\",VLOOKUP(K4,O146:Q153,2))","v":""},{"$f":"IF(ISERROR(VLOOKUP(K4,O146:Q153,3)),\"\",VLOOKUP(K4,O146:Q153,3))","v":""},null,null,null,"太陽光が\nある場合\n希望する","太陽熱利用：なし\n木質燃料ストーブ：なし\nその他：なし",null,"希望する","都市ガス",{"$f":"IF(AND(H19=\"\",H20=\"\",H21=\"\"),\"\",IF(J31=V135,\"約\"&TEXT(ROUNDUP((H19*27+H20/46.05*156+H21/37.04*88)/10000,1),\"####0.0\")&\"万円/年\",IF(J31=V136,\"約\"&TEXT(ROUNDUP((H19*27+H20/104.22*706+H21/37.04*88)/10000,1),\"####0.0\")&\"万円/年\",\"\")))","v":""},{"$f":"IF(OR(J31=V135,J31=V136),\"電気:27円/kWh\",\"\")","v":""}]
[null,null,null,null,"太陽光発電",null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(E151,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(E151,ROW($1:$16))))","v":""},null,null,{"$f":"IF(K21=\"\",\"\",IF(K21<=K22,\"適合\",\"－\"))","v":""},{"$f":"IF(L21=\"\",\"\",IF(L21<=L22,\"適合\",\"－\"))","v":""},null,null,null,null,null,null,null,"ＬＰガス",null,{"$f":"IF(OR(J31=V135,J31=V136),\"都市:156円/㎥\",\"\")","v":""}]
[null,null,"売電量［MJ］",null,"コージェネレーション",null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(E152,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(E152,ROW($1:$16))))","v":""},null,"強化外皮基準",{"$f":"IF(ISERROR(VLOOKUP(K4,O146:R153,4)),\"\",VLOOKUP(K4,O146:R153,4))","v":""},null,null,null,null,null,null,null,"希望しない","－",null,{"$f":"IF(OR(J31=V135,J31=V136),\"LP:706円/㎥\",\"\")","v":""},null,null,null,null,"非表示（Workエリア）"]
[null,null,null,null,"太陽光発電",null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(E153,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(E153,ROW($1:$16))))","v":""},null,null,{"$f":"IF(K21=\"\",\"\",IF(K21<=K24,\"適合\",\"－\"))","v":""},null,null,null,null,"その他の場合 （「2．BELS評価申請項目」の表で直接選択）",null,null,null,null,null,{"$f":"IF(OR(J31=V135,J31=V136),\"灯油:88円/ℓ\",\"\")","v":""},null,null,null,null,0,"評価申請選択（1-4）：初期値は0"]
[]
[null,"2. BELS評価申請項目"]
[null,"再エネ設備の有無",null,null,{"$f":"IF(J8=\"\",\"\",IF(OR(AA29,AB29,AC29,AD29),Z135,IF(OR(AA25=1,AA25=2,AA25=3),Z136,Z137)))","v":""},null,"再エネ種類",null,null,null,null,null,null,{"$f":"IF(AD29,T139,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($H$23=\"\",$H$23=0),FALSE,TRUE)","v":false},{"$f":"IF($S$193=\"無し\",FALSE,TRUE)","v":false},{"$f":"IF($V$191=\"無し\",FALSE,TRUE)","v":false},null,"管理用（初期設定復帰用）"]
[null,"再エネ容量の表示希望",null,null,{"$f":"IF(J8=\"\",\"\",IF(E28=Z136,X138,IF(AND(H23<>\"\",H23<>0,OR(AA25=1,AA25=2,AA25=3)),X135,X137)))","v":""},null,"再エネ容量",{"$f":"IF(OR(J8=\"\",E29=X138),\"\",IF(E29=X136,\"－\",IF(P195=0,\"\",P195&\"kW\")))","v":""},{"$f":"IF(OR(J8=\"\",E29=X138),\"\",IF(E29=X136,\"－\",\"\"))","v":""},{"$f":"IF(OR(J8=\"\",E29=X138),\"\",IF(E29=X136,\"－\",\"\"))","v":""},{"$f":"IF(OR(J8=\"\",E29=X138),\"\",IF(E29=X136,\"－\",\"\"))","v":""},null,null,{"$f":"IF(E29=X135,IF(AND(AA29,OR(AB29,AC29,AD29)),X139,IF(AA29,X140,IF(OR(AB29,AC29,AD29),X141,\"\"))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($H$23=\"\",$H$23=0),FALSE,TRUE)","v":false},{"$f":"IF($S$193=\"無し\",FALSE,TRUE)","v":false},{"$f":"IF($V$191=\"無し\",FALSE,TRUE)","v":false},null,"実行用"]
[null,"エネルギーの多段階表示",null,null,{"$f":"IF(J8=\"\",\"\",IF(OR(H23=\"\",H23=0),W135,W136))","v":""},null,"「ZEHマーク」",{"$f":"IF(J8=\"\",\"\",IF(AND(K21<=K24,L21<=L22,W108>=20,W111>=100,H23>0),P135,IF(AND(K21<=K24,L21<=L22,W108>=20,W111>=75,W111<100,H23>0),P136,IF(AND(K21<=K24,L21<=L22,W108>=20),P139,P138))))","v":""},null,"ZEH Orientedの要件",null,{"$f":"IF(H30=\"\",\"\",IF(H30=P137,Y135,Y136))","v":""},null,{"$f":"IF(H30=P139,P141,IF(H30=P137,P140,\"\"))","v":""}]
[null,"目安光熱費の表示",null,null,{"$f":"IF(OR(J5=R136,J5=R137,AC29),U136,IF(J8=\"\",\"\",IF(OR(AA25=1,AA25=2),U135,IF(AA25=3,U136,U137))))","v":""},null,"ガス設備の選択",null,null,{"$f":"IF(OR(E31=U136,AA25=3,AC29),V138,IF(AA25=1,V135,IF(AA25=2,V136,IF(E31=U135,V137,\"\"))))","v":""},null,null,null,{"$f":"IF(AC29,U139,\"\")","v":""}]
[]
[null,"3. BELS評価プレビュー （※端数処理等の影響でBELS評価書と誤差が生じることがあります。相違時はBELS評価書を優先します。）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,0]
[null,"住宅（住戸）",null,null,null,"エネルギー消費性能",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"★","🌟","☆"]
[null,null,null,null,null,{"$f":"IF(AA42=3,$AC$34,IF(AA42=2,$AB$34,IF(AA42=1,$AA$34,\"\")))","v":""},"","","","",""]
[null,"物件概要"]
[null,"建物名称："]
[null,{"$f":"IF(E4=\"\",\"\",IF(OR(RIGHT(E4,9)=\" ( 戸建住宅 )\",RIGHT(E4,9)=\" ( 共同住宅 )\"),LEFT(E4,LEN(E4)-9),E4))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6]
[null,{"$f":"IF(K4=\"\",\"地域の区分：\",\"地域の区分：\"&K4&\"地域\")","v":"地域の区分："},null,null,{"$f":"IF(E30=W135,\"★ 再エネなしの一次エネルギー消費量削減率\",\"★ 再エネなしの一次エネルギー消費量削減率　　🌟 太陽光発電分の一次エネルギー消費量削減率\")","v":"★ 再エネなしの一次エネルギー消費量削減率　　🌟 太陽光発電分の一次エネルギー消費量削減率"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E45=\"\",0,IF(E45>=0,1,IF(H45>=0,2,3)))","v":0},{"$f":"IF(E45=\"\",0,IF(E45>=0.1,1,IF(H45>=0.1,2,3)))","v":0},{"$f":"IF(E45=\"\",0,IF(E45>=0.2,1,IF(H45>=0.2,2,3)))","v":0},{"$f":"IF(E45=\"\",0,IF(E45>=0.3,1,IF(H45>=0.3,2,3)))","v":0},{"$f":"IF(E45=\"\",0,IF(E45>=0.4,1,IF(H45>=0.4,2,3)))","v":0},{"$f":"IF(E45=\"\",0,IF(E45>=0.5,1,IF(H45>=0.5,2,3)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4]
[null,"評価概要",null,null,"再エネなし",null,null,"再エネあり\n（自家消費分）",null,null,"再エネあり\n（自家消費分＋売電分）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E45=\"\",0,IF(E45>=0,1,3))","v":0},{"$f":"IF(E45=\"\",0,IF(E45>=0.1,1,3))","v":0},{"$f":"IF(E45=\"\",0,IF(E45>=0.2,1,3))","v":0},{"$f":"IF(E45=\"\",0,IF(E45>=0.3,1,3))","v":0}]
[null,"評価対象：住宅",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E30=W136,AA39,\"\")","v":""},{"$f":"IF(E30=W136,AB39,IF(E30=W135,AB41,\"\"))","v":""},{"$f":"IF(E30=W136,AC39,IF(E30=W135,AC41,\"\"))","v":""},{"$f":"IF(E30=W136,AD39,IF(E30=W135,AD41,\"\"))","v":""},{"$f":"IF(E30=W136,AE39,IF(E30=W135,AE41,\"\"))","v":""},{"$f":"IF(E30=W136,AF39,\"\")","v":""}]
[null,{"$f":"IF(I4=\"\",\"\",IF(COUNTIF(I4,\"*\"&\"戸建\"&\"*\"),\"（一戸建ての住宅）\",IF(COUNTIF(I4,\"*\"&\"共同\"&\"*\"),\"（店舗等併用住宅の住戸部分）\",\"\")))","v":""},null,null,"削減率","BEI値",null,"削減率","BEI値",null,"削減率","BEI値",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"非表示（Workエリア）"]
[null,"評価手法："]
[null,"・一次エネルギー消費量",null,null,{"$f":"IF(W108=\"\",\"\",W108/100)","v":""},{"$f":"IF(W108=\"\",\"\",AC183)","v":""},null,{"$f":"IF(W108=\"\",\"\",IF(E30=W135,\"━\",T187/100))","v":""},{"$f":"IF(E30=W135,\"━\",AC181)","v":""},null,{"$f":"IF(W108=\"\",\"\",IF(E30=W135,\"━\",W112/100))","v":""},{"$f":"IF(W108=\"\",\"\",IF(E30=W135,\"━\",1-W112/100))","v":""}]
[null,{"$f":"IF(J5=R139,\"\",\" \"&J5)","v":" "}]
[null,"・断熱性能（外皮性能）"]
[null,{"$f":"\" \"&E5","v":" "},null,null,"断 熱 性 能"]
[null,"XMLID：",null,null,"UA値","ηAC値"]
[null,{"$f":"IF(ISERROR(D131),\"\",\" \"&MID(D131,10,18))","v":" "},null,null,null,null,{"$f":"IF($P157>3,3,IF($P157=3,\"3以下\",\"-\"))","v":"-"},{"$f":"IF($P157>=4,4,\"-\")","v":"-"},{"$f":"IF($P157>=5,5,\"-\")","v":"-"},{"$f":"IF($P157>=6,6,\"-\")","v":"-"},{"$f":"IF($P157>=7,7,\"-\")","v":"-"}]
[null,"再出力コード :",null,null,{"$f":"K21","v":""},{"$f":"L21","v":""}]
[null,{"$f":"IF(ISERROR(D131),\"\",\" \"&RIGHT(D131,19))","v":" "}]
[]
[null,"目安光熱費",null,null,"達 成 項 目"]
[null,{"$f":"IF(E31=U136,\"なし\",IF(AND(E31=U135,J31=V135),\"ガス設備：\"&J31,IF(AND(E31=U135,J31=V136),\"ガス設備：\",\"\")))","v":""},null,null,"ZEH水準\n（誘導基準）",null,"ネット・ゼロ・\nエネルギー",null,"再エネ設備"]
[null,{"$f":"IF(E31=U136,\"\",IF(AND(E31=U135,J31=V136),\" \"&J31,\"\"))","v":""}]
[null,null,null,null,{"$f":"IF(L65=\"達成\",\"☑\",\"-\")","v":"-"},null,{"$f":"IF(AND(E45<>\"\",X119=\"適合\"),\"☑\",\"-\")","v":"-"},{"$f":"IF(X119=\"適合\",V119,\"－\")","v":"－"},{"$f":"IF(OR(E28=Z135,E28=Z136),E28,\"\")","v":""},{"$f":"IF(AA29,\"太陽光発電\",\"－\")","v":"－"},{"$f":"IF(E29=X135,H29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AB29,\"太陽熱利用\",\"－\")","v":"－"},{"$f":"IF(E29=X135,I29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AC29,\"木質ストーブ\",\"－\")","v":"－"},{"$f":"IF(E29=X135,J29,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AD29,IF(L28=\"\",\"その他\",L28),\"－\")","v":"－"},{"$f":"IF(E29=X135,K29,\"\")","v":""}]
[]
[null,"省エネ性能","基準","一次エネルギー消費性能（GJ/年）",null,null,"断熱性能",null,null,null,null,"総合判定"]
[null,null,null,"設計一次","基準一次","判定","UA値","基準（UA）","ηAC値","基準（η）","判定"]
[null,null,"省エネ基準",{"$f":"IF(AB159=0,\"\",AB159)","v":""},{"$f":"IF(AB160=0,\"\",AB160)","v":""},{"$f":"IF(D64=\"\",\"\",IF(D64<=E64,\"達成\",\"非達成\"))","v":""},{"$f":"K21","v":""},{"$f":"P159","v":""},{"$f":"L21","v":""},{"$f":"Q159","v":""},{"$f":"IF(G64=\"\",\"\",IF(AND(G64<=H64,I64<=J64),\"達成\",\"非達成\"))","v":""},{"$f":"IF(F64=\"\",\"\",IF(AND(F64=\"達成\",K64=\"達成\"),\"達成\",\"非達成\"))","v":""}]
[null,null,"誘導基準",{"$f":"IF(AB163=0,\"\",AB163)","v":""},{"$f":"IF(AB164=0,\"\",AB164)","v":""},{"$f":"IF(D65=\"\",\"\",IF(D65<=E65,\"達成\",\"非達成\"))","v":""},{"$f":"K21","v":""},{"$f":"R159","v":""},{"$f":"L21","v":""},{"$f":"S159","v":""},{"$f":"IF(G65=\"\",\"\",IF(AND(G65<=H65,I65<=J65),\"達成\",\"非達成\"))","v":""},{"$f":"IF(F65=\"\",\"\",IF(AND(F65=\"達成\",K65=\"達成\"),\"達成\",\"非達成\"))","v":""}]
[]
[null,"特記項目","再エネ等除いた削減率",null,{"$f":"IF(ISERROR(W108/100),\"\",IF(E69=\"－\",E69,W108/100))","v":""},null,null,"参考情報","等級","設計値","基準値","表示値"]
[null,null,"再エネ等加えた削減率",null,{"$f":"IF(ISERROR(W111/100),\"\",IF(OR(E69=\"－\",E69=$P$137),\"－\",W111/100))","v":""},null,null,"5-1 ※",{"$f":"S125","v":""},{"$f":"IF(K21=\"\",\"\",TEXT(K21,\"0.00\")&\"/\"&TEXT(L21,\"0.0\"))","v":""},{"$f":"IF(I68=4,Q157,IF(I68=5,S157,IF(I68=6,U157,IF(I68=7,W157,\"\"))))","v":""},{"$f":"IF(OR(I68=7,AND(K4=8,I68=6)),J68,IF(I68=\"\",\"\",\"－\"))","v":""}]
[null,null,"「ZEHマーク」",null,{"$f":"IF(H30=\"\",\"\",IF(X119=\"適合\",H30,IF(OR(H30=P135,H30=P136,H30=P137),H30&\"　不適合\",\"－\")))","v":""},null,null,"5-2",{"$f":"S126","v":""},{"$f":"IF(S128=\"\",\"\",TEXT(S128,\"#####.0\")&\" GJ\")","v":""},{"$f":"IF(S127=\"\",\"\",TEXT(S127,\"#####.0\")&\" GJ\")","v":""},{"$f":"IF(OR(S129=\"－\",S129=\"\"),S129,S129&\" MJ/㎡\")","v":""}]
["非表示（様式拡張用の予備スペース）"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["99行まで非表示（様式拡張用の予備スペース）"]
[null,null,null,null,null,null,null,"※ 結露の基準を満たす必要あり",null,null," ⇐ PDF貼付けセル"]
["非表示（Ｊ100セルから読込開始）"]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"抽出文字列","抽出結果","Work or 説明",null,null,null,null,null,null,null," "]
[null,null,"1．住宅タイプの設計一次エネルギー消費量等",null,null,null,null,null,null,null,null,null," ",null,"●旧評価書記載事項【計算結果・設計内容（現況）説明書記載事項】"]
[null,null,"名称",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&C105&\"*\",$J$100:$J$499,0),1))","v":""},{"$f":"IF(D105<>\"\",MID(D105,FIND(\"(建て方)\",D105)+6,LEN(D105)),\"\")","v":""},null,null,null,null,null,null,null," ",null,"「ZEHマーク」に関する事項"]
[null,null,"床面積",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&C106&\"*\",$J$100:$J$499,0)+1,1))","v":""},null,null,null,null,null,null,null,null," ",null,"再生可能エネルギー等除き",null,null,"設計一次エネルギー消費量（その他除く） GJ",null,null,null,null,{"$f":"IF(ISERROR(AC182),\"\",AC182)","v":0}]
[null,null,"地域の区分",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&C107&\"*\",$J$100:$J$499,0),1))","v":""},null,null,null,null,null,null,null,null," ",null,null,null,null,"一次エネルギー消費削減量（その他除く） GJ",null,null,null,null,{"$f":"IF(ISERROR(J18-AC182),\"\",J18-AC182)","v":""}]
[null,null,"暖房設備",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C108&\"*\",$J$100:$J$499,0),1))","v":""},null,null,null,null,null,null,null,null," ",null,null,null,null,"一次エネルギー消費量（その他除く）の削減率　　％",null,null,null,null,{"$f":"T184","v":""}]
[null,null,"冷房設備","",null,null,null,null,null,null,null,null," ",null,"再生可能エネルギー等加え",null,null,"設計一次エネルギー消費量（その他除く） GJ",null,null,null,null,{"$f":"IF(ISERROR(AC184),\"\",AC184)","v":0}]
[null,null,"換気設備","",null,null,null,null,null,null,null,null," ",null,null,null,null,"一次エネルギー消費削減量（その他除く） GJ",null,null,null,null,{"$f":"IF(ISERROR(J18-AC184),\"\",J18-AC184)","v":""}]
[null,null,"給湯設備","",null,null,null,null,null,null,null,null," ",null,null,null,null,"一次エネルギー消費量（その他除く）の削減率　　％",null,null,null,null,{"$f":"T185","v":""},null,"第二面"]
[null,null,"照明設備","",null,null,null,null,null,null,null,null," ",null,null,null,null,"一次エネルギー消費量（その他除く）の削減率　　％",null,null,null,null,{"$f":"T186","v":""},null,"第一面"]
[null,null,"その他の設備","",null,null,null,null,null,null,null,null," "]
[null,null,"太陽光発電(PV)",{"$f":"IF(ISERROR(INDEX($J$100:$J$499,MATCH(C114&\"*\",$J$100:$J$499,0),1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C114&\"*\",$J$100:$J$499,0),1)))","v":""},null,null,null,null,null,null,null,null," "]
[null,null,"コージェネレーション設備の売電量に係る控除量",{"$f":"IF(ISERROR(INDEX($J$100:$J$499,MATCH(C115&\"*\",$J$100:$J$499,0),1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C115&\"*\",$J$100:$J$499,0)-1,1)))","v":""},null,null,null,null,null,null,null,null," ",null,"●旧評価書記載事項【評価書プレビュー】"]
[null,null,"↓",{"$f":"IF(ISERROR(INDEX($J$100:$J$499,MATCH(C115&\"*\",$J$100:$J$499,0),1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C115&\"*\",$J$100:$J$499,0),1)))","v":""},null,null,null,null,null,null,null,null," ",null,"一面","BEIの値（削減率）",null,null,{"$f":"L18","v":""},{"$f":"IF(S116=\"\",\"\",\"(\"&ROUND((1-S116)*100,0)&\"%削減)\")","v":""},{"$f":"IF(COUNTBLANK(S116)=1,\"\",IF(U145<>\"適合\",\"－\",IF(S116<=0.8,\"☆☆☆☆☆\",IF(AND(S116>0.8,S116<=0.85),\"☆☆☆☆\",IF(AND(S116>0.85,S116<=0.9),\"☆☆☆\",IF(AND(S116>0.9,S116<=1),\"☆☆\",IF(AND(S116>1,S116<=1.1),\"☆\",\"－\")))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,"単位面積当たりの\n一次エネルギー消費量(MJ/㎡・年)",null,null,"設計値（その他除く）",null,{"$f":"IF(E6=\"\",\"\",ROUNDUP(H18*1000/E6,0))","v":""},"設計値（その他含む）",null,{"$f":"IF(E6=\"\",\"\",ROUNDUP((AB159*1000)/E6,0))","v":""}]
[null,null,"2．判定",null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,"基準値（その他除く）",null,{"$f":"IF(E6=\"\",\"\",ROUNDUP(AB159*1000/E6,0))","v":""},"基準値（その他含む）",null,{"$f":"IF(E6=\"\",\"\",ROUNDUP(AB160*1000/E6,0))","v":""}]
[null,null,"H28年4月以降",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C119&\"*\",$J$100:$J$499,0)+1,1))","v":""},"等級4設計",null,null,null,null,null,null,null," ",null,null,"「ＺＥＨマーク」、「ゼロエネ相当」、「ZEH-Mマーク」に関する事項　／　判定",null,null,null,null,null,{"$f":"IF(H30=\"\",\"\",H30)","v":""},null,{"$f":"IF(ISERROR(IF(OR(H30=\"\",K4=\"\",AND(K4<8,K21=\"\"),W108=\"\",W111=\"\"),\"\",IF(OR(AND(H30=P135,K21<=K24,L21<=L22,W108>=20,W111>=100,H23>0),AND(H30=P136,K21<=K24,L21<=L22,W108>=20,W111>=75,W111<100,H23>0),AND(H30=P137,K21<=K24,L21<=L22,W108>=20,W111<75,H23>0),AND(H30=P137,K21<=K24,L21<=L22,W108>=20,H23=0),AND(H30=P137,K21<=K24,L21<=L22,W108>=20,H23=\"\")),\"適合\",\"－\"))),\"－\",IF(OR(H30=\"\",K4=\"\",AND(K4<8,K21=\"\"),W108=\"\",W111=\"\"),\"\",IF(OR(AND(H30=P135,K21<=K24,L21<=L22,W108>=20,W111>=100,H23>0),AND(H30=P136,K21<=K24,L21<=L22,W108>=20,W111>=75,W111<100,H23>0),AND(H30=P137,K21<=K24,L21<=L22,W108>=20,W111<75,H23>0),AND(H30=P137,K21<=K24,L21<=L22,W108>=20,H23=0),AND(H30=P137,K21<=K24,L21<=L22,W108>=20,H23=\"\")),\"適合\",\"－\")))","v":""}]
[null,null,"H28年4月現存",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C120&\"*\",$J$100:$J$499,0)-1,1))","v":""},"等級4基準",null,null,null,null,null,null,null," ",null,null,"再生可能エネルギーを除いた設計一次エネルギー消費量の基準一次エネルギー消費量からの削減率",null,null,null,null,null,null,null,{"$f":"W108","v":""},"%削減"]
[null,null,null,{"$f":"D119","v":""},"等級5設計",null,null,null,null,null,null,null," ",null,null,"再生可能エネルギーを加えた設計一次エネルギー消費量の基準一次エネルギー消費量からの削減率",null,null,null,null,null,null,null,{"$f":"IF(V119=P137,\"\",W111)","v":""},"%削減"]
[null,null,"低炭素化の促進のために誘導すべきその他の基準",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C122&\"*\",$J$100:$J$499,0)-1,1))","v":""},"等級5基準",null,null,null,null,null,null,null," "]
[null,null,"R04年10月以降",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C123&\"*\",$J$100:$J$499,0)+1,1))","v":""},"等級6設計",null,null,null,null,null,null,null," "]
[null,null,"R04年10月現存",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C124&\"*\",$J$100:$J$499,0)-1,1))","v":""},"等級6基準",null,null,null,null,null,null,null," ",null,"●旧評価書記載事項【参考情報　品確法 5-1、5-2 等級判定】"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"5-1　等級　（4・5・6・7）",null,null,null,{"$f":"IF(K4=\"\",\"\",IF(W158=\"適合\",7,IF(U158=\"適合\",6,IF(S158=\"適合\",5,IF(Q158=\"適合\",4,\"－\")))))","v":""}]
[null,null,"3．BEI",null,null,null,null,null,null,null,null,null," ",null,"5-2　等級　（4・5・6）",null,null,null,{"$f":"IF(AB159=0,\"\",IF(AE168=\"適合\",6,IF(AC168=\"適合\",5,IF(AA168=\"適合\",4,\"－\"))))","v":""}]
[null,null,"一次エネルギー消費量(その他除く)",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&C127&\"*\",$J$100:$J$499,0)+4,1))","v":""},"省エネ基準：設計",null,null,null,null,null,null,null," ",null,{"$f":"IF(S126=\"\",\"\",S126)","v":""},"基準一次エネルギー　[GJ]",null,null,{"$f":"IF(S126=6,AB164,IF(S126=5,AB162,IF(S126=4,AB160,\"\")))","v":""}]
[null,null,"↓",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&C127&\"*\",$J$100:$J$499,0)+5,1))","v":""},"基準エネルギー",null,null,null,null,null,null,null," ",null,{"$f":"IF(S126=\"\",\"\",S126)","v":""},"設計一次エネルギー　[GJ]",null,null,{"$f":"IF(S126=6,AB163,IF(S126=5,AB161,IF(S126=4,AB159,\"\")))","v":""}]
[null,null,"↓",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&C127&\"*\",$J$100:$J$499,0)+6,1))","v":""},"省エネ基準：BEI",null,null,null,null,null,null,null," ",null,"設計一次エネルギー表示値　[MJ/㎡・年]",null,null,null,{"$f":"IF(OR(S128=\"\",E6=\"\"),\"\",IF(S126=6,ROUNDUP(S128*1000/E6,0),\"－\"))","v":""}]
[null,null,"↓",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&C127&\"*\",$J$100:$J$499,0)+7,1))","v":""},"誘導基準：設計・BEI",null,null,null,null,null,null,null," "]
[null,null,"XML ID",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C131&\"*\",$J$100:$J$499,0),1))","v":""},null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"●データの入力規則"]
[null,null,"4．住宅タイプの仕様",null,null,null,null,null,null,null,null,null," ",null,null,"ＺＥＨマーク",null,"一次エネ設計","外皮設計","再エネ設備","光熱費","ガス種類","省エネ表示","容量表示","ZEH Oriented要件","再エネ設備"]
[null,null,"外皮性能の評価方法",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&C134&\"*\",$J$100:$J$499,0),1))","v":""},null,null,null,null,null,null,null,null," ",null,"H28年基準",null,"国土交通省告示第489号に準拠した計算方法"]
[null,null,"外皮平均熱貫流率",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&C135&\"*\",$J$100:$J$499,0),1))","v":""},{"$f":"IF(RIGHT(D135,1)=\"）\",LEFT(D135,FIND(\"（\",D135)-2),D135)","v":""},null,null,null,null,null,null,null," ",null,"H25年基準","『ＺＥＨ』","ネット・ゼロ・エネルギー・ハウス支援事業が採用している計算方法","性能基準（平成28年基準）","性能基準（平成28年基準）","太陽光発電","希望する","都市ガス","４段階","希望する","適合","あり"]
[null,null,"平均日射熱取得率",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&C136&\"*\",$J$100:$J$499,0),1))","v":""},{"$f":"IF(D136=\"\",\"\",MID(D136,FIND(\"ηAC\",D136)+6,3))","v":""},null,null,null,null,null,null,null," ",null,null,"Ｎｅａｒｌｙ　ＺＥＨ",null,"仕様基準（平成28年基準）","仕様基準（平成28年基準）","太陽熱利用","希望しない","液化石油ガス（ＬＰガス）","６段階","希望しない","－","なし"]
[null,null,"その1",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C137&\"*\",$J$100:$J$499,0),1))","v":""},null,null,null,null,null,null,null,null," ",null,null,"ＺＥＨ　Ｏｒｉｅｎｔｅｄ",null,"誘導仕様基準（平成28年基準）","誘導仕様基準（平成28年基準）","その他（　　　　　　　）","選択してください","選択してください",null,"選択してください",null,"選択してください"]
[null,null,"その2",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C138&\"*\",$J$100:$J$499,0),1))","v":""},null,null,null,null,null,null,null,null," ",null,null,"記載しない",null,"国土交通大臣が認める方法","国土交通大臣が認める方法","－",null,"選択不要",null,"選択不要"]
[null,null,"その3",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C139&\"*\",$J$100:$J$499,0),1))","v":""},null,null,null,null,null,null,null,null," ",null,null,"記載しない（※）",null,"選択してください","選択してください"," ※　その他の再エネ利用設備名を「その他／」の右側に記載してください。"," ※　木質燃料ストーブがある場合は、目安光熱費の表示はできません。",null,null," ※　太陽光発電の容量を確認してください。太陽光発電以外の再エネ設備の容量は、各設備の下の欄に記載してください。"]
[null,null,"その4",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C140&\"*\",$J$100:$J$499,0),1))","v":""},null,null,null,null,null,null,null,null," ",null,null," ※　ZEH Orientedの要件に適合しない場合は、ZEH Orientedを選択できません。",null,null,null,null,null,null,null," ※　太陽光発電の容量を確認してください。"]
[null,null,"J.液体集熱",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C141&\"*\",$J$100:$J$499,0),1))","v":""},null,null,null,null,null,null,null,null," ",null,null," ※　ZEH Orientedの要件に適合する場合は、ZEH Orientedの選択が可能な性能値です。",null,null,null,null,null,null,null," ※　再エネ設備の容量は、各設備の下の欄に記載してください。"]
[null,null,"K.空気集熱",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C142&\"*\",$J$100:$J$499,0)+3,1))","v":""},null,null,null,null,null,null,null,null," "]
[null,null,"ストーブ",{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&C143&\"*\",$J$100:$J$499,0),1))","v":""},null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"●地域区分・断熱性能Work"]
[null,null,"5．参考値",null,null,null,null,null,null,null,null,null," ",null,{"$f":"K4","v":""},null,null,{"$f":"IF(ISERROR(VLOOKUP(K4,O146:R153,4)),\"\",VLOOKUP(K4,O146:R153,4))","v":""},null,"省エネ基準",{"$f":"IF(OR(AND(K4>=5,K4<=7,K21<=K22,L21<=L22),AND(K4=8,L21<=L22),AND(K4<=4,K21<=K22)),\"適合\",\"－\")","v":"－"}]
[null,null,"消費電力量[kWh] *1 ガス消費量[MJ] 灯油消費量[MJ]",{"$f":"IF(ISERROR(INDEX($J$100:$J$499,MATCH(C146&\"*\",$J$100:$J$499,0)+1,1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C146&\"*\",$J$100:$J$499,0)+1,1)))","v":""},{"$f":"IF(D146<>\"\",D146,\"\")","v":""},"消費電力量",null,null,null,null,null,null," ",null,1,0.46,"-",0.4]
[null,null,null,"↓",{"$f":"IF(D146<>\"\",MID(D146,FIND(\" \",D146)+1,20),\"\")","v":""},"ガス消費量",null,null,null,null,null,null," ",null,2,0.46,"-",0.4]
[null,null,null,"↓",{"$f":"IF(D146<>\"\",MID(D146,FIND(\"★\",SUBSTITUTE(D146,\" \",\"★\",2))+1,20),\"\")","v":""},"灯油消費量",null,null,null,null,null,null," ",null,3,0.56000000000000005,"-",0.5]
[null,null,null,"↓",{"$f":"IF(D146<>\"\",MID(D146,FIND(\"★\",SUBSTITUTE(D146,\" \",\"★\",3))+1,20),\"\")","v":""},"コージェネ売電ガス控除量",null,null,null,null,null,null," ",null,4,0.75,"-",0.6]
[null,null,"コージェネレーション太陽光発電コージェネレーション太陽光発電",{"$f":"IF(ISERROR(INDEX($J$100:$J$499,MATCH(C150&\"*\",$J$100:$J$499,0)+1,1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(C150&\"*\",$J$100:$J$499,0)+1,1)))","v":""},{"$f":"IF(D150<>\"\",D150,\"\")","v":""},"発電CGS",null,null,null,null,null,null," ",null,5,0.87,3,0.6]
[null,null,null,"↓",{"$f":"IF(D150<>\"\",MID(D150,FIND(\" \",D150)+1,20),\"\")","v":""},"発電太陽光",null,null,null,null,null,null," ",null,6,0.87,2.8,0.6]
[null,null,null,"↓",{"$f":"IF(D150<>\"\",MID(D150,FIND(\"★\",SUBSTITUTE(D150,\" \",\"★\",2))+1,20),\"\")","v":""},"売電CGS",null,null,null,null,null,null," ",null,7,0.87,2.7,0.6]
[null,null,null,"↓",{"$f":"IF(D150<>\"\",MID(D150,FIND(\"★\",SUBSTITUTE(D150,\" \",\"★\",3))+1,20),\"\")","v":""},"売電太陽光",null,null,null,null,null,null," ",null,8,"-",6.7,"-"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"-","□","□","□"]
[null,null,"読込み方法（PDF種類）",null,null,null,null,null,null,null,null,null," "]
[null,null,"適判用",{"$f":"IF($J$100=\"\",\"\",IF(ISERROR(INDEX($J$100:$J$499,MATCH(C156,$J$100:$J$499,0),1)),\"PDF\",INDEX($J$100:$J$499,MATCH(C156,$J$100:$J$499,0),1)))","v":""},{"$f":"IF(D156=\"適判用\",\"【適判用PDF読込】\",IF(D156=\"PDF\",\"【PDF読込】\",\"\"))","v":""},null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"●5-1work",{"$f":"IF(K4=\"\",0,IF(W158=\"適合\",7,IF(U158=\"適合\",6,IF(S158=\"適合\",5,IF(Q158=\"適合\",4,3)))))","v":0},{"$f":"TEXT(P159,\"0.00\")&\"/\"&TEXT(Q159,\"0.0\")","v":"/"},null,{"$f":"TEXT(R159,\"0.00\")&\"/\"&TEXT(S159,\"0.0\")","v":"/"},null,{"$f":"TEXT(T159,\"0.00\")&\"/\"&TEXT(U159,\"0.0\")","v":"/"},null,{"$f":"TEXT(V159,\"0.00\")&\"/\"&TEXT(W159,\"0.0\")","v":"/"},null,"●5-2work"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"地域区分","5-1等級4",{"$f":"IF(OR(AND(K4>=5,K4<=7,K21<=P159,L21<=Q159),AND(K4=8,L21<=Q159),AND(K4<=4,K21<=P159)),\"適合\",\"－\")","v":"－"},"5-1等級5",{"$f":"IF(OR(AND(K4>=5,K4<=7,K21<=R159,L21<=S159),AND(K4=8,L21<=S159),AND(K4<=4,K21<=R159)),\"適合\",\"－\")","v":"－"},"5-1等級6",{"$f":"IF(OR(AND(K4>=5,K4<=7,K21<=T159,L21<=U159),AND(K4=8,L21<=U159),AND(K4<=4,K21<=T159)),\"適合\",\"－\")","v":"－"},"5-1等級7",{"$f":"IF(OR(AND(K4>=5,K4<=7,K21<=V159,L21<=W159),AND(K4<=4,K21<=V159)),\"適合\",\"－\")","v":"－"},null,"等級区分","PDF読込","計算値","採用値"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"K4","v":""},{"$f":"IF(ISERROR(VLOOKUP(O159,O160:W167,4)),\"\",VLOOKUP(O159,O160:W167,2))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O159,O160:W167,4)),\"\",VLOOKUP(O159,O160:W167,3))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O159,O160:W167,4)),\"\",VLOOKUP(O159,O160:W167,4))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O159,O160:W167,4)),\"\",VLOOKUP(O159,O160:W167,5))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O159,O160:W167,4)),\"\",VLOOKUP(O159,O160:W167,6))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O159,O160:W167,4)),\"\",VLOOKUP(O159,O160:W167,7))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O159,O160:W167,4)),\"\",VLOOKUP(O159,O160:W167,8))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O159,O160:W167,4)),\"\",VLOOKUP(O159,O160:W167,9))","v":""},null,"等級4設計",{"$f":"IF(OR(ISERROR(D119),D119=\"\"),\"\",-LOOKUP(1,-LEFT(MID(D119,1,15),ROW($1:$16))))","v":""},{"$f":"ROUNDUP(SUM(H8,H9,H10,H11,H12,H13,H14,H15,H16)/1000,1)","v":0},{"$f":"IF(Z159=\"\",AA159,Z159)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,1,0.46,"-",0.4,"-",0.28000000000000003,"-",0.2,"-",null,"等級4基準",{"$f":"IF(OR(ISERROR(D120),D120=\"\"),\"\",IF(RIGHT(D120,3)=\"非達成\",-LOOKUP(1,-RIGHT(LEFT(D120,LEN(D120)-4),ROW($1:$16))),-LOOKUP(1,-RIGHT(LEFT(D120,LEN(D120)-3),ROW($1:$16)))))","v":""},{"$f":"ROUNDUP(SUM(J8,J9,J10,J11,J12,H13)/1000,1)","v":0},{"$f":"IF(Z160=\"\",AA160,Z160)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,2,0.46,"-",0.4,"-",0.28000000000000003,"-",0.2,"-",null,"等級5設計",{"$f":"IF(OR(ISERROR(D121),D121=\"\"),\"\",-LOOKUP(1,-LEFT(MID(D121,1,15),ROW($1:$16))))","v":""},{"$f":"ROUNDUP(SUM(H8,H9,H10,H11,H12,H13,H14,H15,H16)/1000,1)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,3,0.56000000000000005,"-",0.5,"-",0.28000000000000003,"-",0.2,"-",null,"等級5基準",{"$f":"IF(OR(ISERROR(D122),D122=\"\"),\"\",-LOOKUP(1,-LEFT(MID(D122,10,15),ROW($1:$16))))","v":""},{"$f":"ROUNDUP((SUM(J8,J9,J10,J11,J12)*0.9+SUM(H13))/1000,1)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,4,0.75,"-",0.6,"-",0.34,"-",0.23,"-",null,"等級6設計",{"$f":"IF(OR(ISERROR(D123),D123=\"\"),\"\",-LOOKUP(1,-LEFT(MID(D123,1,15),ROW($1:$16))))","v":""},{"$f":"ROUNDUP((SUM(H8,H9,H10,H11,H12,H13,H16,H24)-SUM(H22))/1000,1)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,5,0.87,3,0.6,3,0.46,3,0.26,3,null,"等級6基準",{"$f":"IF(OR(ISERROR(D124),D124=\"\"),\"\",IF(RIGHT(D124,3)=\"非達成\",-LOOKUP(1,-RIGHT(LEFT(D124,LEN(D124)-4),ROW($1:$16))),-LOOKUP(1,-RIGHT(LEFT(D124,LEN(D124)-3),ROW($1:$16)))))","v":""},{"$f":"ROUNDUP((SUM(J8,J9,J10,J11,J12)*0.8+SUM(H13))/1000,1)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,6,0.87,2.8,0.6,2.8,0.46,2.8,0.26,2.8]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,7,0.87,2.7,0.6,2.7,0.46,2.7,0.26,2.7]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,8,"-",6.7,"-",6.7,"-",5.0999999999999996,"-","-",null,"●5-2等級適合"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"-","□","□","□","□","□","□","□","□",null,"5-2等級","等級4",{"$f":"IF(AB159<=AB160,\"適合\",\"－\")","v":"適合"},"等級5",{"$f":"IF(AB161<=AB162,\"適合\",\"－\")","v":"適合"},"等級6",{"$f":"IF(AB163<=AB164,\"適合\",\"－\")","v":"適合"}]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"●一次エネルギー消費量（MJ値から計算）",null,null,null,null,"●PDF数値読込のエラー防止（計算時はSUM関数で二重にエラー防止）"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"他除","他除",null,{"$f":"IF(ISNUMBER(H14),H14,0)","v":0},"数値以外の場合は0",null,"PV自家消費"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"MJ","GJ",null,{"$f":"IF(ISNUMBER(H15),H15,0)","v":0},"数値以外の場合は0",null,"CGS自家消費"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"基準一次エネルギー",null,{"$f":"SUM(J8:L12)","v":0},{"$f":"ROUNDUP(Q174/1000,1)","v":0},null,{"$f":"IF(ISNUMBER(H16),H16,0)","v":0},"数値以外の場合は0",null,"CGS売電控除"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,{"$f":"IF(ISNUMBER(H22),H22,0)","v":0},"数値以外の場合は0",null,"CGS発電"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"設計一次エネルギー",null,"MJ",null,null,{"$f":"IF(ISNUMBER(H23),H23,0)","v":0},"数値以外の場合は0",null,"PV発電"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"設備合計",null,{"$f":"SUM(H8:I12)","v":0},null,null,{"$f":"IF(ISNUMBER(H24),H24,0)","v":0},"数値以外の場合は0",null,"CGS売電",null,"●BEI Work"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"発電量合計",null,null,null,null,{"$f":"IF(ISNUMBER(H25),H25,0)","v":0},"数値以外の場合は0",null,"PV売電",null,"BEI 区分",null,"PDF読込","計算値","採用値"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"CGS自家消費（発電－売電）＋売電控除",null,{"$f":"IF(ISBLANK(H22),\"\",SUM(T175)-SUM(T177)+SUM(T174)*(-1))","v":0},null,null,null,null,null,null,null,"基準エネルギー",null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(D128,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(D128,ROW($1:$16))))","v":""},{"$f":"TEXT(R174,\"####################.0\")*1","v":0},{"$f":"IF(AA179=\"\",IF(J18=\"\",AB179,J18),AA179)","v":0},"2025/9/18読込値に変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"自家消費＋CGS売電控除",null,{"$f":"IF(ISBLANK(H15),\"\",SUM(T172)*(-1)+SUM(T175)-SUM(T177)+SUM(T174)*(-1))","v":0},null,null,null,null,null,null,null,"省エネ基準：設計",null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(D127,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(D127,ROW($1:$16))))","v":""},{"$f":"TEXT(R185,\"####################.0\")*1","v":0},{"$f":"IF(AA180=\"\",IF(H18=\"\",AB180,H18),AA180)","v":0},"2025/9/18読込値に変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"発電量(CGS＋PV）",null,{"$f":"IF(OR(AND(ISBLANK(H23),ISBLANK(H22)),E6=\"\"),\"\",SUM(T175)+SUM(T176)*(SUM(E6)/SUM(E6,J6)))","v":""},"（PVのみ非住宅と按分する）",null,"●ZEH計算方法",null,null,null,null,"省エネ基準：BEI",null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(D129,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(D129,ROW($1:$16))))","v":""},{"$f":"IF(AB179=0,\"\",ROUNDUP(AB180/AB179,2))","v":""},{"$f":"IF(AA181=\"\",IF(L18=\"\",AB181,L18),AA181)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"CGS消費＋発電(PVのみ）",null,{"$f":"IF(OR(ISBLANK(H23),E6=\"\"),\"\",SUM(T175)-SUM(T177)+SUM(T174)*(-1)+SUM(T176)*1)","v":""},"（PVは非住宅と按分しない）",null,{"$f":"Q134","v":"国土交通省告示第489号に準拠した計算方法"},null,null,null,null,"誘導基準：設計",null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(D130,17,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(D130,17,15),ROW($1:$16))))","v":""},{"$f":"TEXT(R184,\"####################.0\")*1","v":0},{"$f":"IF(AA182=\"\",AB182,AA182)","v":0},"2025/9/18読込値に変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"設計一次エネ",null,null,null,null,"告示準拠",null,null,null,null,"誘導基準：BEI",null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(D130,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(D130,ROW($1:$16))))","v":""},{"$f":"IF(AB179=0,\"\",ROUNDUP(AB182/AB179,2))","v":""},{"$f":"IF(AA183=\"\",AB183,AA183)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"再除",null,{"$f":"Q$177-SUM(Q179)","v":0},{"$f":"ROUNDUP(Q184/1000,1)","v":0},null,{"$f":"IF(ISERROR((AC179-AC182)/AC179),\"\",IF(AC179-AC182>=0,ROUNDDOWN((AC179-AC182)/AC179*100,0),ROUNDUP((AC179-AC182)/AC179*100,0)))","v":""},"再エネ除く削減率",null,null,null,"再エネ含む（総売電）：設計",null,{"$f":"IF(AND(OR(H24=\"\",H24=0),OR(H23=\"\",H23=0)),AA180,\"\")","v":""},{"$f":"TEXT(R186,\"####################.0\")*1","v":0},{"$f":"IF(AA184=\"\",AB184,AA184)","v":0},"2025/9/18読込値に変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"再含（自家消費）",null,{"$f":"Q$177-SUM(Q180)","v":0},{"$f":"ROUNDUP(Q185/1000,1)","v":0},null,{"$f":"IF(ISERROR((AC179-AC184)/AC179),\"\",IF(AC179-AC184>=0,ROUNDDOWN((AC179-AC184)/AC179*100,0),ROUNDUP((AC179-AC184)/AC179*100,0)))","v":""},"再エネ含む削減率（総売電）：第二面",null,null,null,"再エネ含む：BEI",null,{"$f":"IF(AND(OR(H24=\"\",H24=0),OR(H23=\"\",H23=0)),AA181,\"\")","v":""},{"$f":"IF(AB179=0,\"\",IF(AB184<0,ROUNDDOWN(AB184/AB179,2),ROUNDUP(AB184/AB179,2)))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"再含（自消＋総売電）",null,{"$f":"Q$177-SUM(Q181)","v":0},{"$f":"IF(Q186<0,ROUNDDOWN(Q186/1000,1),ROUNDUP(Q186/1000,1))","v":0},null,{"$f":"IF(ISERROR((AC179-AC186)/AC179),\"\",IF(AC179-AC186>=0,ROUNDDOWN((AC179-AC186)/AC179*100,0),ROUNDUP((AC179-AC186)/AC179*100,0)))","v":""},"再エネ含む削減率（PV売電のみ）：第一面",null,null,null,"再エネ含む（PV売電のみ）：設計",null,{"$f":"IF(AND(OR(H24=\"\",H24=0),OR(H23=\"\",H23=0)),AA180,\"\")","v":""},{"$f":"TEXT(R187,\"####################.0\")*1","v":0},{"$f":"IF(AA186=\"\",AB186,AA186)","v":0},"2025/9/18読込値に変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"再含（自消＋PV売電）",null,{"$f":"Q$177-SUM(Q182)","v":0},{"$f":"IF(Q187<0,ROUNDDOWN(Q187/1000,1),ROUNDUP(Q187/1000,1))","v":0},null,{"$f":"IF(ISERROR((AC179-AC180)/AC179),\"\",IF(AC179-AC180>=0,ROUNDDOWN((AC179-AC180)/AC179*100,0),ROUNDUP((AC179-AC180)/AC179*100,0)))","v":""},"再エネ含む削減率（自家消費）：第一面"]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"●太陽光発電容量",null,null,"●太陽熱利用の有無",null,null,"●木質燃料ストーブの有無"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"その１",{"$f":"IF(ISERROR(D137),0,IF(LEN(D137)<20,0,-LOOKUP(1,-LEFT(MID(D137,20,6),ROW($1:$16)))))","v":0},null,"J.液体集熱",{"$f":"IF(ISERROR(D141),\"無し\",IF(D141=\"\",\"無し\",IF(RIGHT(D141,5)=\"設置しない\",\"無し\",\"有り\")))","v":"無し"},null,"判定",{"$f":"IF(ISERROR(D143),\"無し\",IF(D143=\"\",\"無し\",IF(RIGHT(D143,4)=\"ストーブ\",\"有り\",\"無し\")))","v":"無し"}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"その２",{"$f":"IF(ISERROR(D138),0,IF(LEN(D138)<20,0,-LOOKUP(1,-LEFT(MID(D138,20,6),ROW($1:$16)))))","v":0},null,"K.空気集熱",{"$f":"IF(ISERROR(D142),\"無し\",IF(D142=\"\",\"無し\",IF(RIGHT(D142,5)=\"設置しない\",\"無し\",\"有り\")))","v":"無し"}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"その３",{"$f":"IF(ISERROR(D139),0,IF(LEN(D139)<20,0,-LOOKUP(1,-LEFT(MID(D139,20,6),ROW($1:$16)))))","v":0},null,"判定",{"$f":"IF(AND(S191=\"無し\",S192=\"無し\"),\"無し\",\"有り\")","v":"無し"}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"その４",{"$f":"IF(ISERROR(D140),0,IF(LEN(D140)<20,0,-LOOKUP(1,-LEFT(MID(D140,20,6),ROW($1:$16)))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"合計",{"$f":"SUM(P191:P194)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"按分合計",{"$f":"IF(E6=\"\",\"\",ROUND(P195*SUM(E6)/SUM(E6,J6),2))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"更新履歴(V7.0以降)"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V7.0","2018-07-09","入力項目変更（売電量追加）"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V7.1","2018-08-01","一次エネルギー計算結果改訂（V2.4.1以降）に伴う変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V7.2","2018-10-01","一次エネルギー計算結果改訂（V2.4.2以降）に伴う変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V8.0","2018-10-05","一次エネルギー計算結果改訂（V2.5以降）に伴う変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V8.1","2019-10-01","一次エネルギー計算結果改訂（V2.5.1以降）に伴う変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V8.2","2019-12-16","ZEH Oriented 注記変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V8.3","2020-02-18","地域区分記載改訂（V2.7.2以降)に伴う変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V8.4","2020-05-13","一次エネ計算V2.8.1に対応、住戸名称取得変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V8.41","2020-09-29","ZEH Oriented エネルギー削減率表記変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V8.5","2021-04-01","一次エネ計算V3に対応、UA値取得変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V9.0","2021-08-01","ZEH適合判定条件に太陽光発電有りのチェックを追加"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V9.2","2022-04-05","PDF表示方式対応、入力・読込修正欄変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V9.3","2022-06-01","BELS評価書交付プログラムV10.3.0対応"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V9.4","2022-07-07","動作改善"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V9.61","2022-11-07","V3.3.x 対応"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V9.62","2023-01-06","等級判定改修（その他含むGJ合計値使用）"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V9.8","2023-04-03","併用住宅の5-1等級6,7表示対応"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V9.9","2023-09-22","外皮性能評価手法表示、等級参考表示変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V10.0","2024-02-26","省エネ性能表示対応、BELS新様式対応"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V10.1","2024-05-28","WEBプロV3.3以降対応に限定、目安光熱費参考表示、ZEH水準の判定変更（誘導基準達成）"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V11.0","2024-10-01","WEBプロV3.7対応、削減率表記改定（ZEH無ければ非表示）（、「当該住戸の外皮面積を用いず外皮性能を評価する」廃止対応～大臣の方法は残す）"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V11.1","2024-12-11","再エネ含む削減率算定改修（太陽光無し、コージェネ売電有りに対応）"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V12.0","2025-04-01","４段階表示様式変更、木質燃料ストーブ追加、PDF・省エネ適判登録PDF読込み表示、BELS申請項目・一次エネルギー消費性能注釈改修、非住宅との再エネ共有ルーチン変更（太陽光発電に加えてCGS売電も共有、CGS売電は初めに読み込んだ計算対象床面積で按分、太陽光発電は住宅タブで修正後の床面積で按分されている）、NumLock復帰ルーチン改修"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V12.1","2025-05-01","削減率、BEIの算出を設備のMJ合計からの計算に暫定的に変更（BELS評価書に合わせる）、第一面の再エネ含む削減率にCGS売電を除外（第二面の特記にはCGS売電考慮）"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V12.2","2025-06-01","削減率はMJ計算、BEIはWEBプロから引用"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"第一面の売電含む削減率は非住宅との共有を考慮しない、コージェネ売電は再エネ含む削減率からは除外する"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"断熱性能4未満はすべて「3以下」と表記する"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V12.3","2025-07-11","第二面の再エネ含む削減率は非住宅との按分からCGS売電を除く（太陽光発電のみ按分処理を行う）"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"V12.4","2025-09-17","BELS評価書交付プログラムV13.4対応（削減率を読込値に変更してBEIと一致させる）、ZEH Oriented・ZEH-M Oriented適合条件改定"]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"改善課題","・BELS評価書の削減率の整合（現状は一面二面の削減率は設計・基準共にMJ値で計算していて、WEBプロに記載のその他除くGJ合計、BEIと異なる場合がある）"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,"（売電の非住宅共有は、太陽光売電量が削減量に余分に加算されている）"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,"　～評価書プログラム改定時に不整合事例の検証を行い、評価書プログラムの修正が確認できれば課題から外す（或いは正常化する）"]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"499行まで非表示"]